create external table jms_dm.dm_report_site_errscan_detail_dt 
(
scan_time_ff string COMMENT '扫描日期_f' ,
scan_time timestamp COMMENT '扫描日期' ,
site_code string COMMENT '网点编号' ,
site_name string COMMENT '网点名称' ,
proxy_area_code string COMMENT '代理区编号' ,
proxy_area_name string COMMENT '代理区名称' ,
franchisees_code string COMMENT '加盟商编号' ,
franchisees_name string COMMENT '加盟商名称' ,
billcode string COMMENT '单号' ,
nextstation string COMMENT '下一站名称' ,
nextstationcode string COMMENT '下一站编码' ,
next_network_type  string COMMENT '下一站类型' ,
real_arrival_scantype string COMMENT '实际扫描类型' ,
arrival_time timestamp COMMENT '到件时间' ,
arrival_scan_site_code string COMMENT '到件网点' ,
bill_type string COMMENT '进出港类型' ,
should_arrival_scantype string COMMENT '应扫描类型' ,
CREATE_TIME string COMMENT '创建日期' )
comment '集散到件错扫'
PARTITIONED BY ( dt string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_report_site_errscan_detail_dt'
TBLPROPERTIES (     'discover.partitions' = 'false',  'parquet.column.index.access' = 'true');
